
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sp_SinhVien_InsertSinhVien]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[sp_SinhVien_InsertSinhVien]
GO
create procedure sp_SinhVien_InsertSinhVien
	@MaSV varchar(10),
	@Ten_SV nvarchar(100),
	@Ngay_Sinh datetime,
	@Gioi_Tinh nvarchar(40),
	@Dia_chi nvarchar(100)	
as
begin			
	INSERT INTO SinhVien
		(
			MaSV,
			Ten_SV,			
			Ngay_Sinh,
			Gioi_Tinh,
			Dia_Chi
		)	
	VALUES	
		(
			@MaSV,
			@Ten_SV,			
			@Ngay_Sinh,
			@Gioi_Tinh,
			@Dia_Chi
		)
end



